2017-08-25 - 52850 - Breakfix - ABAP Add additional fields to ZMMREP report #ProductionBreakFix #mmppreports

2017-08-25 - 52850 - Break Fix - ABAP Add additional fields to ZMMREP report


Problem Summary


Add additional fields to ZMMREP report, please see document for details.

Admin Info


Purpose
ABAP Add additional fields to ZMMREP report
Requested by
Babu Vanamali
Issue Date
08-25-2017
Resolved by
Damodhier, Adithya
Resolved Date
08-29-2017
Document Status
Complete

Detailed Problem Description

(Include Screen Shots if required )

ZMMREP report is widely used globally and business is expecting some more information to make this report to have information normally business pull from other reports and combine to meet their day to day needs. With these new fields save time for most of the departments/business users globally.

1) Approval SKU
2) Retail flag
3) Include at Menlo
4) PMS Color
5) Material creation date
6) Special procurement description
7) Add Primary Vendor
8) FOB Price and Currency of primary vendor

on Date 09/06/2017.

Add Two More fields to the report:
1. Primary Vendor Name.
2. PMS Color Description.

Solution Analysis and Recommendations

(Include Screen Shots if required)

Add below new fields to the report ZMMREP:

1) Approval SKU (Table: ZMAT_AP - ZAPP_ID)
2) Retail flag (Table: MVKE - PRAT5)
3) Include at Menlo (Table: MVKE - PRAT4)
4) PMS Color (Table: MARA - ZZPMSCOLOR)
5) Material creation date (Table MARA – ERSDA)
6) Special procurement description (MARC – SOBSL already exists, add its description)
7) Add Primary Vendor (EORD – FLIFN)
8) FOB Price and Currency of primary vendor (Table A965)

Resolution


New fields ZAPP_ID, PRAT5, PRAT4, ZZPMSCOLOR, ERSDA,LTEXT (SOBSL description), LIFNR (Primary Vendor), KBETR (FOB Price) & KONWA (FOB Currency) and their logic has been added in the program ZREP_MM.


Release Information


Provide link here to Release Notes if Technical Objects were changed
2017-08-30 - 52850 - Rel Notes - ABAP Add additional fields to ZMMREP report
2017-09-08 - 52850 - Rel Notes - ABAP Add additional fields to ZMMREP report2